SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+sales +clearance' IN BOOLEAN MODE)) AND iCityID IN (67345,67804,70240,67420,70239,67245,68979,69977,69775,67640,67571) ORDER BY FIELD(iCityID, 67345,67804,70240,67420,70239,67245,68979,69977,69775,67640,67571) ASC, p.tmPosted DESC LIMIT 24 sales clearance, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Sirohi

Items for sale in Sirohi - sales clearance

No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

Sirohi

Items for Sale

Items for sale in Sirohi - sales clearance

Similar searches: